|
Course
Title |
Applied Computer
Technology, CIS 103-018 |
|
Course
Description |
This
course is a combination of the study of Microsoft Office 2007 and a survey of
comperization and it's techniques on the Internet, among social networks and
computer equipment. As far as office is concerned, a 'detailed' study will
involve Word (for word processing) and Excel (for spreadsheets) with emphasis
on using these office components for future academic requirements. A brief
analysis of another office component, Access, may be part of this class and
it is probable that another component, Powerpoint, will be used for a
takehome final. As far as the computer survey, discussion should be provided
on digital devices, including cameras, and on social networks such as
Facebook |
|
Course
Scheduling |
Monday
and Wednesday, 9AM to 1, West Philadelphia campus of Community College Of
Philadelphia, meeting from 7/13/09 through 8/26/09 (WERC) |
|
Instructor
Info |
Marc
Rauer's Emails: 777rauer@voicenet.com, rauer777@verizon.net and
mrauer@ccp.edu. Please, for your benefit, use 777rauer@voicenet.com as this
has the most capacity of all these emails and is looked at the most often |
|
Text
Info |
Applied
Computer Technology CIS 103 by Rutkowsky and Rutkowsky Published by Paradigm
Publishing. This is part of Paradigm's Benchmark Series |
|
Additional
Material |
Students
will need a way of off loading data. The best way to do this is by flash
drive (also known as memory stick or jump disk). You can go to Staples - or
other such stores - and buy these relatively cheap. Another need will be your
own copy (or someone else's) of Micrsosoft Office 2007 and a computer that
can run this software. Many outlets are available to obtain a copy of this
software and the Microsoft site, www.microsoft.com
has several versions available nad even trial versions if the need exists. It
will be very difficult to deal with this course if this software is not
available to you to study on your own. |
|
Additional
Study Facilities |
The
book's publishers maintain a web site for student use. At the time of this
writing, your instructor is not aware of how to direct you to this and when
he finds out, you will find out. However, your instructor is in the process
of enhancing his web site for students which you can find on www.777rauer.com.
This will be enhanced almost every day as we move through the course. At the
moment, a copy of this syllabus and an Email link should be a part of that
web site. You should, for the duration of this class, make it a habit to
check out this site as your instructor will be updating this web site first
as to additional info and material for this course. |
|
Testing |
An
attempt will be made to use the Publisher's SNAP testing facility. You should
be aware that previous attempts at computerized testing (with another
publisher) have been a failure and this instructor was required to go back to
class administered tests. If the SNAP testing facility works, your Word and
Excel tests will be at your convenience, through some time period, to be done
outside of class. If the software does not work, we will return to the old
fashioned in class test. It is expected that there will be a take home
assignment at the end of the session. It is possible, but not certain, that
other assignments for you to do both in class and out of class, individually
and in groups may be assigned. |
|
Week 1 |
Introduction
to the course and an introduction to operating systems. An attempt will be
made to emphasize file structure. The end of the week brings on the study of
Microsoft Word and its elementary functions |
|
Week 2 |
Continuation
of formatting concepts in Word and at the end of the week we get into
inclusion of graphic objects. |
|
Week 3 |
Use
of tables in word. Table is called a construct in data processing as
everything has a table associated with it. Microsoft has greatly enhanced
Word tables as we shall see. The use of tables allows for several additional
elements to be studied designaed by Microsoft as references (what owuld be
considered as academic word processing and we should be starting this by the
end of te 3rd week |
|
Week 4 |
Use
of styles, Themes and review concepts should be subjects of the 4th week of
Microsoft Word |
|
Week 5 |
The
beginning of the 5th week should see a wrapup of word, a test in one form or
the other and the beginning of the study of Excel. |
|
Week 6 |
Introductory
concepts of excel including cell placement and use of addresses. Throughout
our study of Excel, Microsoft supplied function and techniques will be
applied and these include the sun, average, count, max and min functions. If
we have the time the If and pmt function will also be reviewed |
|
Week 7 |
One
of the enhancements in Excel 2007 is the use of the table construct which we
will study during this week of class |
|
Week 8 |
Pivot
tables and charts should be discussed by this time. These are techniques to
break data into easily observed classes, either visually like a chart (graph)
or conceptually like a Pivot table. The use of both of these can greatly
enhance your spreadsheets |
|
Week 9 |
We
end our study of Excel by doing some projects so you can see these concepts
in operations. We will be doing problems as we go along in the previous
weeks, but this will be an attempt to coalesce the concepts of excel in some
practical and facetious projects. Also, expect the Excel test at this point
and depending on the software availability, this will either be in class or
at your convenience outside of class. |
|
Week 10 |
A
librarian will visit us for a lecture on the databases available to you as a
student of Community Collge Of Philadelphia. Previous lectures that the
instructor has attended have been very informative and you should look
forward to this. This lecture will also allow us to discuss databases in
theory and Access, a component of Microsoft Office in specifics |
|
Week 11 |
Wired
and wireless concepts of networking should be the subject of this week's
discussions. Your instructor maintains a home network of 10 to 12 wired
machines and 2 to 3 wireless portables. Perhaps, he will attempt an on-site
demo, but we know at least that he can provide a discussion of wired and
wireless home networks. In addition, bring your questions in about portables
and desktop machines and he will attempt to answer these as best he can. |
|
Week 12 |
Discussion
of the internet and social networking. How do you make a web page and what
does this entail. And, what problems could occur as pertaining to social
netwirking as Facebook. In addition, you may ask what are people and
technicians talking about when talking about viruses and the like? |
|
Week 13 |
We
wrap up this term by discussing Powerpoint. You probably will be assigned a
group project as a take home final although the instructor reserves the right
to assign an individual take home final |
CIS 103 is in the process of being changed and this course content goes
somewhat to what this course will look like a year from now as it offically
morphs into an introduction to technology course. You are acting somewhat like
guinea pigs in this transformation and the progress of this class will be
transmitted to the depart head of the Computer information sciences curriculum.
You are even early on the book as the book officially enters the the course
effective the Fall'09 semester. The instructor volunteered this class (and
volunteered himself with an addtional workload as such) to test out various
components of the present course and what it will turn into. The instructor
thought you should know about this as you are only one of 3 such classes, the
first in this school, operating as such this term
At minimum there will be 4 marking events. Tests in some way for Word and
Excel, a take home in Powerpoint and the instructor's grade in which he
determines your input (and output in some cases) to this class. It should be
clear that there a possibility of assigning additional projects and they would
be included in the marking scheme indicated below (with changes occurring to
the percentages shown). Below is a table showing this marking scheme.
|
Word test |
Somewhere in the 5th week
(corresponds to 3rd week for summer session II |
45 pts |
|
Excel test |
Somewhere in the 9th week
(corresponds to 5th week for summer session II |
45 pts |
|
Powerpoint Project |
End of term during final
week |
10 pts |
|
Instructor portion |
Analysis throughout the
term |
10 pts |
You will notice that this is 110 points. The instructor gives an added 10
points to those who help make this class a success. No such addition is given
to those working in the opposite direction and they are marked on 100 points,
the school norm. What is the instructor looking for in assigning this: regular
and prompt attendance, attention to the material offered in class, infrequent
interuptions both verbally and physically as in leaving the classroom while
lectures are occurring, infrequent use of the internet for activities that are
not part of the class, alertness (and not sleeping) in the class are some of
the factors used. In spite of his demeanor, your instructor tends to know what
is happening in the class but is generally focused enough to ignore anything
but the most blatant interruptions. However, at the point of settling grades,
he is able to integrate your activities in this class for this part of your
mark.
Once your grade is calculated, the instructor can use the school standard
to determine a letter equivalent or he allows himself the option of using a
curve. In previous classes in the last year, no curve was necessary as there
were enough high grades to offset this need.